package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class noticeadd extends HttpServlet {

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		    request. setCharacterEncoding("UTF-8");
		   String title = request.getParameter("title");
		   String content = request.getParameter("content");
		   String type = request.getParameter("type");
		   System.out.println("type="+type);
		   try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		   String url ="jdbc:mysql://localhost:3306/graduatedesign" ;
			  Connection conn = null ;
			  Statement stmt = null ;
			  ResultSet rs = null;
			  SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			  
			  String sql="insert into notices (title,content,type,date) values (?,?,?,?)"; 
			  try {
				conn = DriverManager.getConnection(url, "root", "root") ;
				stmt = conn.createStatement() ;
				PreparedStatement preStmt=conn.prepareStatement(sql);  
	            preStmt.setString(1, title);  
	            preStmt.setString(2, content);  
	            preStmt.setString(3, type);
	            preStmt.setString(4, df.format(new Date()));
	            int suc = preStmt.executeUpdate(); 
	            if(suc!=0){
	            	response.sendRedirect("admin/noticeadd.jsp") ;
	            }
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
				
				
		   
		   
		   
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doGet(request, response);
	}

}
